/ Developer CD Series 1996 March: Reference Library / Dev.CD Mar 96 RL / Dev.CD Mar 96 RL.toast / Technical Documentation / develop / develop Issue 24 / develop Issue 24 code / Scriptable Database 1.0a11.sea / Scriptable Database 1.0a11 / Database demo / About the Scriptable Database

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 07 00 00 09 16 57 68 | 61 74 20 69 73 20 74 68 |......Wh|at is th|
|00000010| 65 20 53 63 72 69 70 74 | 61 62 6c 65 20 44 61 74 |e Script|able Dat|
|00000020| 61 62 61 73 65 3f 0d 54 | 68 65 20 53 63 72 69 70 |abase?.T|he Scrip|
|00000030| 74 61 62 6c 65 20 44 61 | 74 61 62 61 73 65 20 61 |table Da|tabase a|
|00000040| 70 70 6c 69 63 61 74 69 | 6f 6e 20 77 61 73 20 64 |pplicati|on was d|
|00000050| 65 73 69 67 6e 65 64 20 | 74 6f 20 72 75 6e 20 61 |esigned |to run a|
|00000060| 73 20 61 20 66 61 63 65 | 6c 65 73 73 2c 20 62 61 |s a face|less, ba|
|00000070| 63 6b 67 72 6f 75 6e 64 | 2d 6f 6e 6c 79 20 61 70 |ckground|-only ap|
|00000080| 70 6c 69 63 61 74 69 6f | 6e 2e 20 20 43 75 72 72 |plicatio|n.  Curr|
|00000090| 65 6e 74 6c 79 20 69 74 | 20 69 73 20 66 61 63 65 |ently it| is face|
|000000a0| 6c 65 73 73 2c 20 62 75 | 74 20 69 74 20 69 73 20 |less, bu|t it is |
|000000b0| 6e 6f 74 20 62 61 63 6b | 67 72 6f 75 6e 64 2d 6f |not back|ground-o|
|000000c0| 6e 6c 79 2c 20 73 6f 20 | 69 74 20 77 69 6c 6c 20 |nly, so |it will |
|000000d0| 73 68 6f 77 20 75 70 20 | 69 6e 20 74 68 65 20 70 |show up |in the p|
|000000e0| 72 6f 63 65 73 73 20 6d | 65 6e 75 20 28 69 66 20 |rocess m|enu (if |
|000000f0| 79 6f 75 20 62 72 69 6e | 67 20 69 74 20 74 6f 20 |you brin|g it to |
|00000100| 74 68 65 20 66 72 6f 6e | 74 2c 20 79 6f 75 27 6c |the fron|t, you'l|
|00000110| 6c 20 65 6e 64 20 75 70 | 20 77 69 74 68 20 61 20 |l end up| with a |
|00000120| 62 6c 61 6e 6b 20 6d 65 | 6e 75 20 62 61 72 3b 20 |blank me|nu bar; |
|00000130| 63 6c 69 63 6b 20 6f 6e | 20 74 68 65 20 64 65 73 |click on| the des|
|00000140| 6b 74 6f 70 20 74 6f 20 | 62 72 69 6e 67 20 74 68 |ktop to |bring th|
|00000150| 65 20 46 69 6e 64 65 72 | 20 62 61 63 6b 20 74 6f |e Finder| back to|
|00000160| 20 74 68 65 20 66 72 6f | 6e 74 29 2e 20 20 54 68 | the fro|nt).  Th|
|00000170| 65 20 53 63 72 69 70 74 | 61 62 6c 65 20 44 61 74 |e Script|able Dat|
|00000180| 61 62 61 73 65 20 69 73 | 6e 27 74 20 76 65 72 79 |abase is|n't very|
|00000190| 20 67 6f 6f 64 20 61 62 | 6f 75 74 20 73 68 75 74 | good ab|out shut|
|000001a0| 74 69 6e 67 20 69 74 73 | 65 6c 66 20 64 6f 77 6e |ting its|elf down|
|000001b0| 20 77 68 65 6e 20 69 74 | 27 73 20 6e 6f 74 20 69 | when it|'s not i|
|000001c0| 6e 20 75 73 65 20 28 72 | 65 61 64 3a 20 69 74 20 |n use (r|ead: it |
|000001d0| 6e 65 76 65 72 20 64 6f | 65 73 29 2c 20 73 6f 20 |never do|es), so |
|000001e0| 69 74 20 77 6f 75 6c 64 | 20 62 65 20 6b 69 6e 64 |it would| be kind|
|000001f0| 20 6f 66 20 68 61 72 64 | 20 66 6f 72 20 79 6f 75 | of hard| for you|
|00000200| 20 74 6f 20 74 65 6c 6c | 20 69 66 20 69 74 20 77 | to tell| if it w|
|00000210| 61 73 20 65 61 74 69 6e | 67 20 75 70 20 72 65 73 |as eatin|g up res|
|00000220| 6f 75 72 63 65 73 20 6f | 6e 20 79 6f 75 72 20 6d |ources o|n your m|
|00000230| 61 63 68 69 6e 65 20 69 | 66 20 69 74 20 77 61 73 |achine i|f it was|
|00000240| 20 62 61 63 6b 67 72 6f | 75 6e 64 2d 6f 6e 6c 79 | backgro|und-only|
|00000250| 2e 0d 0d 54 68 65 20 53 | 63 72 69 70 74 61 62 6c |...The S|criptabl|
|00000260| 65 20 44 61 74 61 62 61 | 73 65 20 69 73 20 6e 6f |e Databa|se is no|
|00000270| 74 20 61 6e 20 41 70 70 | 6c 65 20 70 72 6f 64 75 |t an App|le produ|
|00000280| 63 74 2c 20 6e 6f 72 20 | 73 68 6f 75 6c 64 20 69 |ct, nor |should i|
|00000290| 74 20 62 65 20 63 6f 6e | 73 69 64 65 72 65 64 20 |t be con|sidered |
|000002a0| 74 6f 20 62 65 20 70 72 | 6f 64 75 63 74 69 6f 6e |to be pr|oduction|
|000002b0| 2d 71 75 61 6c 69 74 79 | 20 63 6f 64 65 2e 20 20 |-quality| code.  |
|000002c0| 49 74 27 73 20 70 72 65 | 74 74 79 20 64 65 63 65 |It's pre|tty dece|
|000002d0| 6e 74 20 73 61 6d 70 6c | 65 20 63 6f 64 65 2c 20 |nt sampl|e code, |
|000002e0| 68 6f 77 65 76 65 72 2c | 20 61 6e 64 20 69 74 20 |however,| and it |
|000002f0| 77 6f 72 6b 73 20 70 72 | 65 74 74 79 20 77 65 6c |works pr|etty wel|
|00000300| 6c 2e 0d 0d 57 68 61 74 | 20 64 6f 65 73 20 74 68 |l...What| does th|
|00000310| 65 20 53 63 72 69 70 74 | 61 62 6c 65 20 44 61 74 |e Script|able Dat|
|00000320| 61 62 61 73 65 20 64 6f | 3f 0d 54 68 65 20 53 63 |abase do|?.The Sc|
|00000330| 72 69 70 74 61 62 6c 65 | 20 44 61 74 61 62 61 73 |riptable| Databas|
|00000340| 65 20 72 65 73 70 6f 6e | 64 73 20 74 6f 20 6d 6f |e respon|ds to mo|
|00000350| 73 74 20 6f 66 20 74 68 | 65 20 41 70 70 6c 65 45 |st of th|e AppleE|
|00000360| 76 65 6e 74 73 20 75 73 | 65 66 75 6c 20 74 6f 20 |vents us|eful to |
|00000370| 73 63 72 69 70 74 73 20 | 28 65 2e 67 2e 20 41 70 |scripts |(e.g. Ap|
|00000380| 70 6c 65 53 63 72 69 70 | 74 2c 20 6f 72 20 6f 74 |pleScrip|t, or ot|
|00000390| 68 65 72 20 4f 53 41 20 | 63 6f 6d 70 6f 6e 65 6e |her OSA |componen|
|000003a0| 74 73 29 2e 20 20 49 74 | 20 69 73 20 74 72 61 6e |ts).  It| is tran|
|000003b0| 73 61 63 74 69 6f 6e 2d | 62 61 73 65 64 2c 20 73 |saction-|based, s|
|000003c0| 6f 20 70 61 72 74 69 61 | 6c 20 63 68 61 6e 67 65 |o partia|l change|
|000003d0| 73 20 77 6f 6e 27 74 20 | 63 6f 72 72 75 70 74 20 |s won't |corrupt |
|000003e0| 79 6f 75 72 20 64 61 74 | 61 62 61 73 65 20 69 66 |your dat|abase if|
|000003f0| 20 79 6f 75 20 72 75 6e | 20 6f 75 74 20 6f 66 20 | you run| out of |
|00000400| 6d 65 6d 6f 72 79 2e 0d | 0d 54 68 65 20 64 61 74 |memory..|.The dat|
|00000410| 61 62 61 73 65 20 6d 6f | 64 65 6c 20 66 6f 6c 6c |abase mo|del foll|
|00000420| 6f 77 73 20 74 68 65 20 | 6f 62 6a 65 63 74 20 73 |ows the |object s|
|00000430| 75 70 70 6f 72 74 20 6c | 69 62 72 61 72 79 20 63 |upport l|ibrary c|
|00000440| 6f 6e 76 65 6e 74 69 6f | 6e 20 6f 66 20 61 20 68 |onventio|n of a h|
|00000450| 69 65 72 61 72 63 68 69 | 63 61 6c 20 74 72 65 65 |ierarchi|cal tree|
|00000460| 20 6f 66 20 65 6c 65 6d | 65 6e 74 73 2c 20 65 61 | of elem|ents, ea|
|00000470| 63 68 20 77 69 74 68 20 | 61 6e 20 61 72 62 69 74 |ch with |an arbit|
|00000480| 72 61 72 79 20 73 65 74 | 20 6f 66 20 70 72 6f 70 |rary set| of prop|
|00000490| 65 72 74 69 65 73 2e 20 | 20 50 72 6f 70 65 72 74 |erties. | Propert|
|000004a0| 69 65 73 20 61 72 65 20 | 73 74 6f 72 65 64 20 69 |ies are |stored i|
|000004b0| 6e 20 61 6e 20 41 56 4c | 20 74 72 65 65 3b 20 74 |n an AVL| tree; t|
|000004c0| 68 65 20 6d 61 78 69 6d | 75 6d 20 73 69 7a 65 20 |he maxim|um size |
|000004d0| 6f 66 20 74 68 65 20 64 | 61 74 61 20 69 6e 20 61 |of the d|ata in a|
|000004e0| 6e 79 20 70 72 6f 70 65 | 72 74 79 20 72 65 63 6f |ny prope|rty reco|
|000004f0| 72 64 20 69 73 20 32 4b | 2e 0d 0d 44 61 74 61 62 |rd is 2K|...Datab|
|00000500| 61 73 65 20 64 6f 63 75 | 6d 65 6e 74 73 20 61 72 |ase docu|ments ar|
|00000510| 65 20 63 61 72 65 66 75 | 6c 6c 79 20 76 65 72 73 |e carefu|lly vers|
|00000520| 69 6f 6e 65 64 2c 20 61 | 6c 6c 6f 77 69 6e 67 20 |ioned, a|llowing |
|00000530| 66 6f 72 20 74 68 65 20 | 70 6f 73 73 69 62 69 6c |for the |possibil|
|00000540| 69 74 79 20 6f 66 20 62 | 61 63 6b 77 61 72 64 73 |ity of b|ackwards|
|00000550| 2d 63 6f 6d 70 61 74 69 | 62 69 6c 69 74 79 20 77 |-compati|bility w|
|00000560| 69 74 68 20 66 75 74 75 | 72 65 20 72 65 6c 65 61 |ith futu|re relea|
|00000570| 73 65 73 20 6f 66 20 74 | 68 65 20 53 63 72 69 70 |ses of t|he Scrip|
|00000580| 74 61 62 6c 65 20 44 61 | 74 61 62 61 73 65 2e 0d |table Da|tabase..|
|00000590| 0d 57 68 61 74 20 64 6f | 65 73 6e 27 74 20 74 68 |.What do|esn't th|
|000005a0| 65 20 53 63 72 69 70 74 | 61 62 6c 65 20 44 61 74 |e Script|able Dat|
|000005b0| 61 62 61 73 65 20 64 6f | 3f 0d 54 68 65 72 65 20 |abase do|?.There |
|000005c0| 61 72 65 20 61 20 6e 75 | 6d 62 65 72 20 6f 66 20 |are a nu|mber of |
|000005d0| 66 65 61 74 75 72 65 73 | 20 74 68 61 74 20 6d 69 |features| that mi|
|000005e0| 67 68 74 20 62 65 20 6e | 69 63 65 20 74 6f 20 68 |ght be n|ice to h|
|000005f0| 61 76 65 20 69 6e 20 61 | 20 64 61 74 61 62 61 73 |ave in a| databas|
|00000600| 65 20 74 68 61 74 20 61 | 72 65 20 6c 61 63 6b 69 |e that a|re lacki|
|00000610| 6e 67 20 69 6e 20 74 68 | 65 20 53 63 72 69 70 74 |ng in th|e Script|
|00000620| 61 62 6c 65 20 44 61 74 | 61 62 61 73 65 2e 20 20 |able Dat|abase.  |
|00000630| 54 68 65 79 20 69 6e 63 | 6c 75 64 65 3a 0d 09 2d |They inc|lude:..-|
|00000640| 20 50 72 6f 70 65 72 74 | 69 65 73 20 63 6f 6e 74 | Propert|ies cont|
|00000650| 61 69 6e 69 6e 67 20 6d | 6f 72 65 20 74 68 61 6e |aining m|ore than|
|00000660| 20 32 4b 20 6f 66 20 64 | 61 74 61 0d 09 2d 20 4d | 2K of d|ata..- M|
|00000670| 6f 72 65 20 65 66 66 69 | 63 69 65 6e 74 20 74 72 |ore effi|cient tr|
|00000680| 65 65 73 20 66 6f 72 20 | 62 65 74 74 65 72 20 6f |ees for |better o|
|00000690| 6e 2d 64 69 73 6b 20 73 | 65 61 72 63 68 69 6e 67 |n-disk s|earching|
|000006a0| 20 28 69 2e 65 2e 20 42 | 54 72 65 65 73 20 69 6e | (i.e. B|Trees in|
|000006b0| 73 74 65 61 64 20 6f 66 | 20 41 56 4c 20 74 72 65 |stead of| AVL tre|
|000006c0| 65 73 29 0d 09 2d 20 52 | 65 6c 61 74 69 6f 6e 61 |es)..- R|elationa|
|000006d0| 6c 20 70 72 6f 70 65 72 | 74 69 65 73 0d 09 2d 20 |l proper|ties..- |
|000006e0| 4e 6f 6e 2d 6d 65 6d 6f | 72 79 2d 72 65 73 69 64 |Non-memo|ry-resid|
|000006f0| 65 6e 74 20 64 61 74 61 | 62 61 73 65 73 20 28 63 |ent data|bases (c|
|00000700| 75 72 72 65 6e 74 6c 79 | 2c 20 64 61 74 61 20 69 |urrently|, data i|
|00000710| 73 20 64 65 6d 61 6e 64 | 2d 6c 6f 61 64 65 64 2c |s demand|-loaded,|
|00000720| 20 62 75 74 20 69 73 20 | 6e 65 76 65 72 20 70 75 | but is |never pu|
|00000730| 72 67 65 64 29 0d 09 2d | 20 46 75 6c 6c 20 74 72 |rged)..-| Full tr|
|00000740| 61 6e 73 61 63 74 69 6f | 6e 20 73 75 70 70 6f 72 |ansactio|n suppor|
|00000750| 74 20 28 65 76 65 72 79 | 20 41 70 70 6c 65 45 76 |t (every| AppleEv|
|00000760| 65 6e 74 20 69 73 20 69 | 74 73 20 6f 77 6e 20 74 |ent is i|ts own t|
|00000770| 72 61 6e 73 61 63 74 69 | 6f 6e 3b 20 74 68 65 20 |ransacti|on; the |
|00000780| 64 61 74 61 62 61 73 65 | 20 73 75 69 74 65 20 64 |database| suite d|
|00000790| 65 66 69 6e 65 73 20 61 | 20 70 72 6f 74 6f 63 6f |efines a| protoco|
|000007a0| 6c 20 77 68 65 72 65 20 | 6d 75 6c 74 69 70 6c 65 |l where |multiple|
|000007b0| 20 65 76 65 6e 74 73 20 | 63 61 6e 20 62 65 20 67 | events |can be g|
|000007c0| 72 6f 75 70 65 64 20 69 | 6e 74 6f 20 61 20 73 69 |rouped i|nto a si|
|000007d0| 6e 67 6c 65 20 74 72 61 | 6e 73 61 63 74 69 6f 6e |ngle tra|nsaction|
|000007e0| 29 0d 0d 57 68 6f 20 77 | 72 6f 74 65 20 74 68 65 |)..Who w|rote the|
|000007f0| 20 53 63 72 69 70 74 61 | 62 6c 65 20 44 61 74 61 | Scripta|ble Data|
|00000800| 62 61 73 65 3f 0d 59 6f | 75 20 6d 61 79 20 62 6c |base?.Yo|u may bl|
|00000810| 61 6d 65 20 61 6c 6c 20 | 62 75 67 73 20 6f 6e 20 |ame all |bugs on |
|00000820| 47 72 65 67 20 41 6e 64 | 65 72 73 6f 6e 2c 20 61 |Greg And|erson, a|
|00000830| 6e 64 20 79 6f 75 20 6d | 61 79 20 63 6f 6d 70 6c |nd you m|ay compl|
|00000840| 61 69 6e 20 61 62 6f 75 | 74 20 73 61 69 64 20 62 |ain abou|t said b|
|00000850| 75 67 73 20 76 69 61 20 | 74 68 65 20 41 70 70 6c |ugs via |the Appl|
|00000860| 65 4c 69 6e 6b 20 61 64 | 64 72 65 73 73 20 47 2e |eLink ad|dress G.|
|00000870| 41 6e 64 65 72 73 6f 6e | 20 6f 72 20 74 68 65 20 |Anderson| or the |
|00000880| 69 6e 74 65 72 6e 65 74 | 20 61 64 64 72 65 73 73 |internet| address|
|00000890| 20 67 72 65 67 67 6f 72 | 40 61 70 70 6c 65 2e 63 | greggor|@apple.c|
|000008a0| 6f 6d 2e 20 20 49 74 20 | 69 73 20 75 6e 6c 69 6b |om.  It |is unlik|
|000008b0| 65 6c 79 20 74 68 61 74 | 20 79 6f 75 72 20 62 75 |ely that| your bu|
|000008c0| 67 73 20 77 69 6c 6c 20 | 62 65 20 70 72 6f 6d 70 |gs will |be promp|
|000008d0| 74 6c 79 20 66 69 78 65 | 64 2c 20 62 75 74 20 79 |tly fixe|d, but y|
|000008e0| 6f 75 20 63 61 6e 20 61 | 74 20 6c 65 61 73 74 20 |ou can a|t least |
|000008f0| 67 65 74 20 61 20 6c 69 | 74 74 6c 65 20 63 6f 6d |get a li|ttle com|
|00000900| 6d 69 73 65 72 61 74 69 | 6f 6e 20 69 6e 20 79 6f |miserati|on in yo|
|00000910| 75 72 20 6d 69 73 65 72 | 79 2e 0d 0d 00 00 00 38 |ur miser|y......8|
|00000920| 00 08 00 02 00 cf f1 54 | 00 cf f1 48 01 df 00 0b |.......T|...H....|
|00000930| 00 cf f1 44 00 00 00 01 | 00 21 00 00 02 fe 00 01 |...D....|.!......|
|00000940| 03 24 00 00 05 8b 00 01 | 05 b4 00 00 07 dd 00 01 |.$......|........|
|00000950| 08 00 00 00 09 17 ff ff | 00 00 00 24 00 04 00 10 |........|...$....|
|00000960| 00 0c 00 01 00 00 00 00 | 00 00 00 00 00 00 00 04 |........|........|
|00000970| 00 10 00 0c 00 01 01 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000980| 00 00 00 c4 00 10 00 0c | 00 10 00 0c 00 10 00 0c |........|........|
|00000990| 00 10 00 0c 00 10 00 0c | 00 10 00 0c 00 10 00 0c |........|........|
|000009a0| 00 10 00 0c 00 10 00 0c | 00 10 00 0c 00 10 00 0c |........|........|
|000009b0| 00 10 00 0c 00 10 00 0c | 00 10 00 0c 00 10 00 0c |........|........|
|000009c0| 00 10 00 0c 00 10 00 0c | 00 10 00 0c 00 10 00 0c |........|........|
|000009d0| 00 10 00 0c 00 10 00 0c | 00 10 00 0c 00 10 00 0c |........|........|
|000009e0| 00 10 00 0c 00 10 00 0c | 00 10 00 0c 00 10 00 0c |........|........|
|000009f0| 00 10 00 0c 00 10 00 0c | 00 10 00 0c 00 10 00 0c |........|........|
|00000a00| 00 10 00 0c 00 10 00 0c | 00 10 00 0c 00 10 00 0c |........|........|
|00000a10| 00 10 00 0c 00 10 00 0c | 00 10 00 0c 00 10 00 0c |........|........|
|00000a20| 00 10 00 0c 00 10 00 0c | 00 10 00 0c 00 10 00 0c |........|........|
|00000a30| 00 10 00 0c 00 10 00 0c | 00 10 00 0c 00 10 00 0c |........|........|
|00000a40| 00 10 00 0c 00 10 00 0c | 00 00 00 08 00 00 00 00 |........|........|
|00000a50| 00 cf f1 40 00 00 00 16 | 00 00 00 00 00 00 00 10 |...@....|........|
|00000a60| 00 0c 00 01 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a70| 00 0c 00 00 00 01 00 71 | 00 67 01 cf 02 60       |.......q|.g...`  |
+--------+-------------------------+-------------------------+--------+--------+